ds=$1

mysql -e "truncate business.bigdata01_ads_t_recent_week_register;" -ubusiness -pBusiness45345..


sqoop export \
--export-dir /daas/motl/bigdata01/dws/dws_t_recent_week_register/ds=${ds} \
--columns create_time,register_num,week_create_time,week_register_num,rate \
--fields-terminated-by ',' \
--connect 'jdbc:mysql://cdh01:3306/business?useUnicode=true&characterEncoding=UTF-8&useSSL=false' \
--username business \
--password Business45345.. \
--table bigdata01_ads_t_recent_week_register \
--num-mappers 1